ExecuteClientSql

/ Assembly List / LJCDBClientLib / ObjectManager`2 / ExecuteClientSql

Namespace - LJCDBClientLib

Parameters

sql - The client SQL statement.

Syntax

C#
public Void ExecuteClientSql(String sql)

Executes a non-query client SQL statement. (E)

Example

C#
// Executes a non-query SQL statement. private static void ExecuteClientSql(ObjectManager<Person, Persons> personManager) { StringBuilder builder = new StringBuilder(64); builder.AppendLine("update PersonTest"); builder.AppendLine("set Name = 'TestNameUpdated'"); builder.AppendLine("where Name = 'TestName'"); string sql = builder.ToString(); // Update the record. personManager.ExecuteClientSql(sql); }

// Executes a non-query SQL statement.
private static void ExecuteClientSql(ObjectManager<Person, Persons> personManager)
{
  StringBuilder builder = new StringBuilder(64);
  builder.AppendLine("update PersonTest");
  builder.AppendLine("set Name = 'TestNameUpdated'");
  builder.AppendLine("where Name = 'TestName'");
  string sql = builder.ToString();

  // Update the record.
  personManager.ExecuteClientSql(sql);
}